{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["index","quadratic","quadratic (2)","complete square"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"index","index":0,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[null,"QUADRATICS"]
[1,"Factorising a simple quadratic"]
[2,"Factorising a harder quadratic - the coefficient of x² is not 1!"]
[3,"Completing the square"]
[null,"© Copyright 2004 S.A.Lomax, M.J.Nixon.  All Rights Reserved."]

{"sheet":"quadratic","index":1,"n_rows":22,"n_cols":14,"rows_kept":22,"cut":false,"hidden":false,"merged":[[10,0,11,0],[10,1,11,2],[10,8,11,8],[10,9,11,9],[10,10,11,10],[10,11,11,11],[10,4,11,4],[10,5,11,5],[10,6,11,6],[10,7,11,7],[10,12,11,12],[10,13,11,13],[10,14,11,14],[3,9,8,11],[10,3,11,3],[3,14,8,14],[3,4,8,4],[3,13,8,13],[3,2,8,2],[3,5,8,5],[3,6,8,6],[3,7,8,7],[3,8,8,8],[3,12,8,12],[3,3,8,3]]}
[]
[null,null,"Factorise the following expression"]
[]
[null,null,null,"x",2,{"$f":"IF(G16<0,\"-\",IF(G16=0,\"\",\"+\"))","v":"-"},{"$f":"IF(G16=0,\"\",ABS(G16))","v":4},{"$f":"IF(G16=0,\"\",\"x\")","v":"x"},{"$f":"IF(G11=L11,\"+\",\"-\")","v":"-"},{"$f":"ABS(E16)","v":12}]
[]
[]
[]
[]
[]
[]
[null,"Answer:",null,null,"(","x",{"$f":"IF(B22=1,\"+\",\"-\")","v":"-"},{"$f":"1+INT(RAND()*9)","v":6},")","(","x",{"$f":"IF(C22=1,\"+\",\"-\")","v":"+"},{"$f":"1+INT(RAND()*9)","v":2},")"]
[]
[]
[null,null,null,1,{"$f":"IF(G11=\"-\",-H11,H11)","v":-6}]
[null,null,1,{"$f":"D14*C15","v":1},{"$f":"E14*C15","v":-6}]
[null,null,{"$f":"IF(L11=\"-\",-M11,M11)","v":2},{"$f":"D14*C16","v":2},{"$f":"E14*C16","v":-12},null,{"$f":"E15+D16","v":-4}]
[]
[]
[]
[]
[]
[null,{"$f":"ROUND(RAND(),0)","v":0},{"$f":"ROUND(RAND(),0)","v":1}]

{"sheet":"quadratic (2)","index":2,"n_rows":22,"n_cols":15,"rows_kept":22,"cut":false,"hidden":false,"merged":[[3,2,8,2],[3,5,8,5],[3,6,8,6],[3,7,8,7],[3,8,8,8],[3,12,8,12],[3,3,8,3],[10,12,11,12],[10,13,11,13],[10,6,11,6],[10,3,11,3],[10,14,11,14],[3,14,8,14],[3,4,8,4],[3,13,8,13],[3,9,8,11],[10,0,11,0],[10,1,11,2],[10,8,11,8],[10,9,11,9],[10,10,11,10],[10,11,11,11],[10,4,11,4],[10,5,11,5],[10,7,11,7]]}
[]
[null,null,"Factorise the following expression"]
[]
[null,null,{"$f":"E11*K11","v":1},"x",2,{"$f":"IF(G16<0,\"-\",IF(G16=0,\"\",\"+\"))","v":"+"},{"$f":"IF(G16=0,\"\",ABS(G16))","v":1},{"$f":"IF(G16=0,\"\",\"x\")","v":"x"},{"$f":"IF(G11=M11,\"+\",\"-\")","v":"-"},{"$f":"N11*H11","v":72}]
[]
[]
[]
[]
[]
[]
[null,"Answer:",null,"(",{"$f":"1+INT(RAND()*4)","v":1},"x",{"$f":"IF(B22=1,\"+\",\"-\")","v":"+"},{"$f":"1+INT(RAND()*9)","v":9},")","(",{"$f":"1+INT(RAND()*3)","v":1},"x",{"$f":"IF(C22=1,\"+\",\"-\")","v":"-"},{"$f":"1+INT(RAND()*9)","v":8},")"]
[]
[]
[null,null,null,{"$f":"E11","v":1},{"$f":"IF(G11=\"-\",-H11,H11)","v":9}]
[null,null,{"$f":"K11","v":1},{"$f":"D14*C15","v":1},{"$f":"E14*C15","v":9}]
[null,null,{"$f":"IF(M11=\"-\",-N11,N11)","v":-8},{"$f":"D14*C16","v":-8},{"$f":"E14*C16","v":-72},null,{"$f":"E15+D16","v":1}]
[]
[]
[]
[]
[]
[null,{"$f":"ROUND(RAND(),0)","v":1},{"$f":"ROUND(RAND(),0)","v":0}]

{"sheet":"complete square","index":3,"n_rows":22,"n_cols":12,"rows_kept":22,"cut":false,"hidden":false,"merged":[[3,14,8,14],[3,4,8,4],[10,14,11,14],[3,9,8,11],[10,9,11,9],[10,5,11,5],[3,3,8,3],[3,12,8,12],[3,13,8,13],[10,6,11,6],[10,10,11,12],[10,3,11,3],[10,7,11,7],[10,13,11,13],[3,2,8,2],[3,5,8,5],[3,6,8,6],[3,7,8,7],[3,8,8,8],[10,0,11,2],[10,8,11,8],[10,4,11,4]]}
[]
[null,"Complete the square for the following expression"]
[]
[null,null,null,"x",2,{"$f":"IF(B22=1,\"+\",\"-\")","v":"-"},{"$f":"2*(1+INT(RAND()*9))","v":16},"x",{"$f":"IF(C22=1,\"+\",\"-\")","v":"+"},{"$f":"1+INT(RAND()*10)","v":9},{"$f":"1+INT(RAND()*9)","v":6},{"$f":"1+INT(RAND()*9)","v":2}]
[]
[null,null,null,null,null,null,{"$f":"1+INT(RAND()*9)","v":3},null,null,{"$f":"1+INT(RAND()*9)","v":2},{"$f":"1+INT(RAND()*9)","v":1},{"$f":"1+INT(RAND()*9)","v":4}]
[]
[null,null,null,null,null,null,{"$f":"1+INT(RAND()*9)","v":7},null,null,{"$f":"1+INT(RAND()*9)","v":3},{"$f":"1+INT(RAND()*9)","v":9},{"$f":"1+INT(RAND()*9)","v":9}]
[]
[]
["Answer:",null,null,"(","x",{"$f":"F4","v":"-"},{"$f":"G4/2","v":8},")",2,{"$f":"IF(K11=0,\"\",IF(L16<0,\"-\",\"+\"))","v":"-"},{"$f":"ABS(L16)","v":55}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(I4=\"-\",-J4,J4)","v":9},null,{"$f":"G11^2","v":64},{"$f":"I16-K16","v":-55}]
[]
[]
[]
[]
[]
[null,{"$f":"ROUND(RAND(),0)","v":0},{"$f":"ROUND(RAND(),0)","v":1}]